--SELECT * FROM PersonEducation
--DELETE FROM PersonEducation
--INSERT INTO srv_lnk.nchr2008.dbo.PersonEducation
SELECT top 5
Convert(int,right(id,7))  AS [ID],Convert(int,right(resumeid,7))  AS [ResumeID],[StartDate] AS [BeginDate],[EndDate] AS [EndDate],[SchoolName] AS [SchoolName],[Major1] AS [MajorSelect],[Major2] AS [SubSelect],[OtherMajor] AS [SubjectName],[EducationLevel] AS [Educational],[IsAbroad] AS [IsStuAbroad],[Notes] AS [OtherInfo],'Chinese' AS [strLanguage],0 AS [Flag],Convert(int,right(resumeid,7)) AS [CreatedUserId],[DateCreated] AS [CreatedDate],Convert(int,right(resumeid,7)) AS [UpdatedUserId],[LastUpdated] AS [UpdatedDate]FROM Forest.dbo.cv_education
SELECT TOP 5 * FROM Forest.dbo.cv_education
select top 5 * from srv_lnk.nchr2008.dbo.PersonEducation
